SELECT * FROM VKPOS WHERE VKPAUFLFD IN ('000460','000443') ORDER BY 5,3,4

SELECT * FROM WDECK WHERE WDAUFLFD IN ('000460','000443') ORDER BY 5,3,4
SELECT * FROM WBBST WHERE WBBSTKNR LIKE '415%' ORDER BY WBBSTKNR
IN ('413-20    ')

SELECT * FROM WBBEW WHERE WBEWSTKNR LIKE '415%'
SELECT * FROM VVTLIEF WHERE VVTLIEFSCH>='00000343'

SELECT VVVSTK FROM VVLIEF   WHERE  VVLIEFSCH>='00000343'
*/
SELECT * FROM WBDAT WHERE WBRWLFD='002840'
WGBST WGMEZUTEI       WGMEZUTEIKG
510     201
750     296
WGAENB  WGAEND
SUNLV           20130226

SELECT * FROM WGBST WHERE WGMANDANT='00'
AND WGSA='00'
AND WGKUNDNR='00000000'
AND WGWERK='   ' AND WGABT='   '
AND WGWAKZ='F'AND WGART = 'PV912102            ' AND WGVAR='12' AND WGFARBE='RD01      'AND WGBESCHICH='F01       '
AND WGDESS='          ' AND WGCOLORIT='          ' AND WGZUSTAND='    ' AND WGZENSUR='1' AND WGZENSURKZ='A'
  AND WGLO='01' AND WGMJJ='2011' AND WGMM='03'

ORDER BY WGMJJ DESC,WGMM DESC
SELECT * FROM WGBST
SELECT * FROM WBDAT WHERE WBRWLFD='002840'
SELECT * FROM WBBST WHERE WBBSTKNR LIKE '415%' ORDER BY WBBSTKNR

DELETE  --select * from
KDSTAMM WHERE KDFILLER LIKE'7a3a2456-986a-4c1f-99d8-1fa61dec685e  %'
GO
DELETE  --select * from
KUNDVER WHERE KDVFILLER LIKE'7a3a2456-986a-4c1f-99d8-1fa61dec685e  %'
GO
DELETE   --select * from
VKKOPF WHERE VKKFILLER LIKE'7a3a2456-986a-4c1f-99d8-1fa61dec685e  %'
GO
DELETE  --select * from
VKPOS WHERE VKPFILLER2 LIKE'7a3a2456-986a-4c1f-99d8-1fa61dec685e  %'
GO
DELETE  --select * from
WDECK WHERE WDFILLER  LIKE'7a3a2456%'
GO

DELETE --select * from
WBBST WHERE WBBFILLER LIKE'7a3a2456-986a-4c1f-99d8-1fa61dec685e  %'
GO
DELETE --SELECT * FROM
 WBBEW WHERE WBEWFILLER LIKE '%7a3a2456-986a-4c1f-99d8-1fa61dec685e  %'
 GO
DELETE --SELECT * FROM
VVLIEF WHERE VVFILLER LIKE '%7a3a2456-986a-4c1f-99d8-1fa61dec685e  %'
GO
DELETE --SELECT * FROM
VVTLIEF WHERE VVTFILLER1 LIKE '%7a3a2456-986a-4c1f-99d8-1fa61dec685e  %'
GO

